SELECT dem.last_name, dem.first_name, d.end_date as "End Date", d.BN,
CONCAT( "" ,
dem.demographic_no, "" ) As "DemLink",
CONCAT( "", dem.demographic_no, "" ) As "ChartLink",
dem.address, dem.city, dem.province, dem.postal, dem.phone, dem.phone2, dem.email, dem.sex, dem.patient_status
FROM demographic dem, drugs d
WHERE d.BN like "%{search}%"
AND d.end_date > "{finish_date}"
AND d.demographic_no = dem.demographic_no
ORDER BY dem.last_name, dem.first_name, d.end_date ;